2014-11-24 - 10735 - Rel Notes - New Era Japan IT Deployment - Sales Order Creation from Order Sheet #SAPReleases2014

Release Notes - Draft

10735 - Rel Notes - New Era Japan IT Deployment - Sales Order Creation from Order Sheet

Admin Info

Purpose
 Sales Order Creation from Order Sheet
Release No
 001
Submitted on
 11/24/2014
Submitted by
 Deepak yasam
Environment
 NECNED to NECNEQ
Sent To
 Daniel Brennan
Object(s) created by
 Venkat kondapally
Object(s) tested by
 Deepak Yasam
Transport Status
 Created in NECNED100

Transport and Technical Objects

Sl.
 Transport ID
 Description
 Object Name
1
 NEDK928199
 SD:10735:Japan Order Sheet Sales Order creation
 ZSD_JPN_ORD_SHT_SO
2
 NEDK927301
 SD:10735:Assign Order Creation to contract creation program
 ZSD_JPN_ORD_SHT_CONTRACT

Release Notes

For Infrastructure

The transports should be imported in the above sequence only to NEQ/NEP.

For Requestor

NA

Test Notes

System : NECNED300


SNo.
 Test Scenarios
 Expected Results
 Actual Results
 P/F
 Load Sheet and Sales Order #
 Notes
 tested by
 QA By
01.
 Fill the order sheet with 3 materials .For item 3 the quantities are not given for the corresponding size and upload into the sell sheet program and execute it.
 Sales Order should not be created as there are no quantities for the size of item 3.
 Sales Order is created with 2 materials.

Exception Reason:
The program will check both the quantities & material and as there is no quantity for item 3, the Sales Order is created with 1, 2 materials.
 P
 SD0821-01

Sales Order # 68627
 N/A
 Deepak
 Deepak
02.
 Fill the order sheet with 3 materials with two valid (item 1, 2) and one invalid material with quantities (item 3).Upload into the sell sheet program and execute it.
 Sales Order should be not be created and the appropriate system message should be displayed on the status bar.
 Sales Order is not created."Material 11099990 is not defined for sales org.3200, distr.Chan.10, language EN" is displayed on the status bar.
 P
 SD0821-02

Sales Order # NA
 N/A
 Deepak
 Deepak
03.
 Upload the order sheet without Ship-to value, into the sell sheet program and execute it.
 Sales Order should not be created.
 Sales Order is created with same SP partner as SH.

Exception Reason:
The program considers SP partner and applies to SH partner in the Sales Order.
 P
 SD0821-03

Sales Order # 68628
 N/A
 Deepak
 Deepak
04.
 Upload the order sheet without Requested delivery date into the sell sheet program and execute it.
 Sales Order should not be created.
 Sales Order is created with requested delivery date.

Exception Reason: The program considering document creation date as requested delivery date in the Sales Order.
 P
 SD0821-04

Sales Order # 68629
 N/A
 Deepak
 Deepak
05.
 Upload the order sheet with invalid month/date into the sell sheet program and execute it.
 Sales Order should not create and message: ‘Enter a valid Date’should come.
 Sales Order is not created and message: ‘Enter a valid Date’ is appeared in the status bar.
 P
 SD0821-05

Sales Order # NA
 N/A
 Deepak
 Deepak
06.
 Upload a protected order sheet, filled with the required data into the sell sheet program then execute it.
 Sales Order should create accordingly with the data filled in excel file.
 Sales Order is created.
 P
 SD0821-06


Sales Order # 68630
 N/A
 Deepak
 Deepak
07.
 Upload an unprotected order sheet, filled with the required data into the sell sheet program then execute it.
 Sales Order should create accordingly with the data filled in excel file.
 Sales Order is created.
 P
 D0821-07

Sales Order # 68631
 N/A
 Deepak
 Deepak
08.
 Upload an order sheet with .xls format filled with the required data into the sell sheet program and execute it.
 Sales Order should create accordingly with the data filled in excel file.
 Sales Order is created.
 P
 SD0821-08

Sales Order # 68632
 N/A
 Deepak
 Deepak
09.
 Upload an order sheet with .xlsx format filled with the required data into the sell sheet program then execute it.
 Sales Order should create accordingly with the data filled in excel file.
 Sales Order is created.
 P
 SD0821-09

Sales Order # 68633
 N/A
 Deepak
 Deepak
10.
 Upload an order sheet, filled with future requested delivery date into the sell sheet program then execute it.
 Sales Order should create with the requested delivery date mentioned in excel file and it should applicable on all the line items.
 Sales Order is created with the future requested delivery date mentioned in excel file and it applied on all the line items in the Sales Order.
 P
 SD0821-10
Sales Order # 68661
 N/A
 Deepak
 Deepak
11.
 Upload an order sheet with same sold-to and ship-to partner into the sell sheet program and execute it.
 Sales Order should create with same partner number as sold-to and ship-to.
 Sales Order created with same partner for both sold-to and ship-to.
 P
 SD0821-11

Sales Order # 68635
 N/A
 Deepak
 Deepak
12.
 Upload an order sheet with different sold-to and ship-to partner into the sell sheet program and execute it.
 Sales Order should create with different sold-to and ship-to partner number.
 Sales Order created with different partners for sold-to and ship-to.
 P
 SD0821-12
Sales Order # 68636
 N/A
 Deepak
 Deepak
13.
 Upload an order sheet with requested delivery date format (MM/DD/YYYY) into the sell sheet program and execute it.
 Sales Order should create with requested delivery date format MM/DD/YYYY at header and it should applicable to all the line items and schedule line level.
 Sales Order created with the date format MM/DD/YYYY.
 P
 SD0821-13
Sales Order # 68637
 N/A
 Deepak
 Deepak
14.
 Upload an order sheet without Cancel date into the sell sheet program and execute it.
 Sales Order should not be created without cancel date.
 Sales Order is created with calculated cancel date.

Exception Reason: As per the custom sell sheet program, if no cancel date is given in the sheet then the program calculates 365 days from the requested delivery date and make the date as cancel date.
 P
 SD0821-14

Sales Order # 68638
 N/A
 Deepak
 Deepak
15.
 Upload an order sheet with invalid grid sizes for the material into the sell sheet program and execute it.
 Sales Order should be created with rejection reason J2 for the invalid sizes.
 Sales Order is created with rejection reason J2 for the invalid sizes.
 P
 SD0821-15
Sales Order # 68612
 N/A
 Deepak
 Deepak
16.
 Upload an order sheet with materials of different master grids in the sell sheet program and execute it.
 Sales Order should create with materials of different master grids.
 Sales Order created with materials of different master grids.
 P
 SD0821-16

Sales Order # 68640
 N/A
 Deepak
 Deepak
17.
 Upload an order sheet as below into the sell sheet program and execute it.

Item-1 with Material number, size, and quantity.

Item -2 with only size and quantity.
 Sales Order should be created with item-1(material number, size and quantity).
 Sales Order is not created and meesage` Invalid material input’ is shown in the status bar
 P
 SD0821-19

Sales Order # NA
 N/A
 Deepak
 Deepak
18.
 Upload an order sheet with 50 items and sizes, to check with many materials.
 Sales Order should create successfully by combining the quantities of a size for each item
 Sales Order is created successfully without any error log.
 P
 SD0821-21
Sales Order # 68677
 N/A
 Deepak
 Deepak
19.
 Upload an order sheet with customer marked for deletion indicator, in the sell sheet program and execute it.
 Sales Order should create and system should prompt message regarding customer marked for deletion, once user display the Sales Order.
 Sales Order created with the customer having deletion indicator enabled.
 P
 SD0821-22
Sales Order # 68642
 N/A
 Deepak
 Deepak
20.
 Upload an order sheet with invalid customer into the sell sheet program and execute it.
 Sales order should not be created and appropriate system message should be displayed on the status bar.
 Sales Order is not created."Invalid SoldTo 0001900000" appeared on the status bar.
 P
 SD0821-23
Sales Order # NA
 N/A
 Deepak
 Deepak
21.
 Fill the order sheet with Materials with enough stock and availability check as Z2 in the MM .Upload into the sell sheet program and execute it.
 Sales Order should be created and quantities should be confirmed on the requested delivery date.
 Sales Order is created and quantities should be confirmed on the requested delivery date.
 P
 SD0821-24
Sales Order # 68643
 N/A
 Deepak
 Deepak
22.
 Fill the order sheet with Materials with no stock and availability check as Z2 in MM. Upload into the sell sheet program and execute it.
 Sales Order should be created by confirming the delivery date as there is no enough stock on the requested delivery date.
 Sales Order is created and system proposed next possible delivery date.
 P
 SD0821-25
Sales Order # 68645
 N/A
 Deepak
 Deepak
23.
 Fill the order sheet with Materials with enough stock and availability check as Z3. Upload into the sell sheet program and execute it.
 Sales Order should be created and quantities should be confirmed on the requested delivery date.
 Sales Order is created and quantities should be confirmed on the requested delivery date.
 P
 SD0821-26
Sales Order # 68646
 N/A
 Deepak
 Deepak
24.
 Fill the order sheet with Materials with no stock and availability check is Z3. Upload into the sell sheet program and execute it.
 Sales Order should be created and material/sizes are rejected with J0 as there is no stock.
 Sales Order is created and material/sizes are rejected with J0 as there is no stock.
 P
 SD0821-27
Sales Order # 68669
 N/A
 Deepak
 Deepak
25.
 Fill the order sheet with items as below with stock available on requested delivery date and upload into the sell sheet program and execute it.

Item-1 - with availability check is Z2

Item-2 - with availability check is Z3
 Sales Order should be created and quantities should be confirmed on the requested delivery date.
 Sales Order is created and quantities are confirmed on the requested delivery date.
 P
 SD0821-28

Sales Order # 68648
 N/A
 Deepak
 Deepak
26
 Fill the order sheet with 2 items as below with no stock available on requested delivery date. Upload into the sell sheet program and execute it.

Item-1 - with availability check is Z3 and

Item-2 with availability check is Z2
 Sales Order should be created and program should propose next possible delivery date for item-2 (Availability check is Z2) and

For item-1 (Availability check is Z3) system should propose rejection reason J0.
 Sales Order created and system proposed next possible delivery date for item-2 (Availability check is Z2) and

for item-1 (Availability check is Z3) rejection reason J0.
 P
 SD0821-29

Sales Order # 68670
 N/A
 Deepak
 Deepak
27
 Input legacy Sold-to & Ship-to
 Sales Order should be created with SAP Sold-to & Ship-to and appropriate system message should be displayed on the status bar.
 Sales Order was created with SAP Sold-to & Ship-to maintained in the legacy table. "NEC Quantity Sales Order 0000068671 has been saved" is displayed on the status bar
 P
 Test4
Sales Order # 0000068671
 N/A
 Deepak
 Deepak
28
 Input legacy Sold-to and SAP Ship-to; SAP Sold-to not maintained in table
 Sales Order should not be created and appropriate system message should appear on the status bar.
 Sales Order was not created. “Invalid SoldTo C00025" appeared on the status bar.
 P
 Test5
Sales Order # NA
 N/A
 Deepak
 Deepak
29
 Input legacy Ship-to and SAP Sold-to; SAP Ship-to not maintained in table
 Sales Order should not be created and appropriate system message should appear on the status bar.
 Sales Order was not created. “Invalid ShipTo M00025”
appeared on the status bar.
 P
 test6
Sales Order # NA
 N/A
 Deepak
 Deepak
30
 Input legacy Sold-to & Ship-to; SAP Sold-to & Ship-to not maintained in table
 Sales Order should not be created and appropriate system message should appear on the status bar.
 Sales Order was not created. “Invalid SoldTo C00025” appeared on the status bar.
 P
 Test7
Sales Order # NA
 N/A
 Deepak
 Deepak
31
 Input SAP Sold-to and legacy Ship-to; Ship-to not maintained in customer master
 Sales Order should not be created and appropriate system message should appear on the status bar.
 Sales Order was not created. “No customer master record exists for customer 2000169” appeared on the status bar.
 P
 Test8
Sales Order # NA
 N/A
 Deepak
 Deepak

SD0821-01.xlsSD0821-02.xlsSD0821-03.xlsSD0821-04.xlsSD0821-05.xlsSD0821-06.xlsSD0821-07.xlsSD0821-08.xls
SD0821-09.xlsSD0821-10.xlsSD0821-11.xlsSD0821-12.xls

SD0821-13.xlsSD0821-14.xlsSD0821-15.xlsSD0821-16.xls
SD0821-19.xlsSD0821-21.xlsSD0821-22.xlsSD0821-23.xls
SD0821-24.xlsSD0821-25.xlsSD0821-26.xlsSD0821-27.xls
SD0821-28.xlsSD0821-29.xlsTest4.xlsx
Test5.xlsxTest6.xlsxTest7.xlsxTest8.xlsx

System: NECNEQ100

None

Reference Document (Specification or Production Support Break Fix)

2014-11-24 - 10735 - Spec - New Era Japan IT Deployment - Sales Order Creation from Order Sheet